3i infotech technical round question

1.self intro
2.daily activites
3.diff between rollback and commit
4.write query using procedure , cursor, eception handling from t1 and t2  tables  having primary and foreign key constraint.